package mobi.hami.huapin.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ProductskuExample {
    /**
     * productsku
     */
    protected String orderByClause;

    /**
     * productsku
     */
    protected boolean distinct;

    /**
     * productsku
     */
    protected List<Criteria> oredCriteria;

    public ProductskuExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * productsku 2018-08-20
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andSkucodeIsNull() {
            addCriterion("skucode is null");
            return (Criteria) this;
        }

        public Criteria andSkucodeIsNotNull() {
            addCriterion("skucode is not null");
            return (Criteria) this;
        }

        public Criteria andSkucodeEqualTo(Integer value) {
            addCriterion("skucode =", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeNotEqualTo(Integer value) {
            addCriterion("skucode <>", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeGreaterThan(Integer value) {
            addCriterion("skucode >", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("skucode >=", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeLessThan(Integer value) {
            addCriterion("skucode <", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeLessThanOrEqualTo(Integer value) {
            addCriterion("skucode <=", value, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeIn(List<Integer> values) {
            addCriterion("skucode in", values, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeNotIn(List<Integer> values) {
            addCriterion("skucode not in", values, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeBetween(Integer value1, Integer value2) {
            addCriterion("skucode between", value1, value2, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkucodeNotBetween(Integer value1, Integer value2) {
            addCriterion("skucode not between", value1, value2, "skucode");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNull() {
            addCriterion("skuname is null");
            return (Criteria) this;
        }

        public Criteria andSkunameIsNotNull() {
            addCriterion("skuname is not null");
            return (Criteria) this;
        }

        public Criteria andSkunameEqualTo(String value) {
            addCriterion("skuname =", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotEqualTo(String value) {
            addCriterion("skuname <>", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThan(String value) {
            addCriterion("skuname >", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameGreaterThanOrEqualTo(String value) {
            addCriterion("skuname >=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThan(String value) {
            addCriterion("skuname <", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLessThanOrEqualTo(String value) {
            addCriterion("skuname <=", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameLike(String value) {
            addCriterion("skuname like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotLike(String value) {
            addCriterion("skuname not like", value, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameIn(List<String> values) {
            addCriterion("skuname in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotIn(List<String> values) {
            addCriterion("skuname not in", values, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameBetween(String value1, String value2) {
            addCriterion("skuname between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andSkunameNotBetween(String value1, String value2) {
            addCriterion("skuname not between", value1, value2, "skuname");
            return (Criteria) this;
        }

        public Criteria andProductidIsNull() {
            addCriterion("productid is null");
            return (Criteria) this;
        }

        public Criteria andProductidIsNotNull() {
            addCriterion("productid is not null");
            return (Criteria) this;
        }

        public Criteria andProductidEqualTo(Integer value) {
            addCriterion("productid =", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotEqualTo(Integer value) {
            addCriterion("productid <>", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThan(Integer value) {
            addCriterion("productid >", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidGreaterThanOrEqualTo(Integer value) {
            addCriterion("productid >=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThan(Integer value) {
            addCriterion("productid <", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidLessThanOrEqualTo(Integer value) {
            addCriterion("productid <=", value, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidIn(List<Integer> values) {
            addCriterion("productid in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotIn(List<Integer> values) {
            addCriterion("productid not in", values, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidBetween(Integer value1, Integer value2) {
            addCriterion("productid between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductidNotBetween(Integer value1, Integer value2) {
            addCriterion("productid not between", value1, value2, "productid");
            return (Criteria) this;
        }

        public Criteria andProductcodeIsNull() {
            addCriterion("productcode is null");
            return (Criteria) this;
        }

        public Criteria andProductcodeIsNotNull() {
            addCriterion("productcode is not null");
            return (Criteria) this;
        }

        public Criteria andProductcodeEqualTo(Integer value) {
            addCriterion("productcode =", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeNotEqualTo(Integer value) {
            addCriterion("productcode <>", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeGreaterThan(Integer value) {
            addCriterion("productcode >", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("productcode >=", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeLessThan(Integer value) {
            addCriterion("productcode <", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeLessThanOrEqualTo(Integer value) {
            addCriterion("productcode <=", value, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeIn(List<Integer> values) {
            addCriterion("productcode in", values, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeNotIn(List<Integer> values) {
            addCriterion("productcode not in", values, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeBetween(Integer value1, Integer value2) {
            addCriterion("productcode between", value1, value2, "productcode");
            return (Criteria) this;
        }

        public Criteria andProductcodeNotBetween(Integer value1, Integer value2) {
            addCriterion("productcode not between", value1, value2, "productcode");
            return (Criteria) this;
        }

        public Criteria andPublishedIsNull() {
            addCriterion("published is null");
            return (Criteria) this;
        }

        public Criteria andPublishedIsNotNull() {
            addCriterion("published is not null");
            return (Criteria) this;
        }

        public Criteria andPublishedEqualTo(Integer value) {
            addCriterion("published =", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedNotEqualTo(Integer value) {
            addCriterion("published <>", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedGreaterThan(Integer value) {
            addCriterion("published >", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedGreaterThanOrEqualTo(Integer value) {
            addCriterion("published >=", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedLessThan(Integer value) {
            addCriterion("published <", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedLessThanOrEqualTo(Integer value) {
            addCriterion("published <=", value, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedIn(List<Integer> values) {
            addCriterion("published in", values, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedNotIn(List<Integer> values) {
            addCriterion("published not in", values, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedBetween(Integer value1, Integer value2) {
            addCriterion("published between", value1, value2, "published");
            return (Criteria) this;
        }

        public Criteria andPublishedNotBetween(Integer value1, Integer value2) {
            addCriterion("published not between", value1, value2, "published");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Integer value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Integer value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Integer value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Integer value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Integer> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Integer> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Integer value1, Integer value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andGmt_createIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmt_createIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmt_createEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_createNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmt_create");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedEqualTo(Date value) {
            addCriterion("gmt_modified =", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedNotEqualTo(Date value) {
            addCriterion("gmt_modified <>", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedGreaterThan(Date value) {
            addCriterion("gmt_modified >", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modified >=", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedLessThan(Date value) {
            addCriterion("gmt_modified <", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modified <=", value, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedIn(List<Date> values) {
            addCriterion("gmt_modified in", values, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedNotIn(List<Date> values) {
            addCriterion("gmt_modified not in", values, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedBetween(Date value1, Date value2) {
            addCriterion("gmt_modified between", value1, value2, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andGmt_modifiedNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmt_modified");
            return (Criteria) this;
        }

        public Criteria andShow_priceIsNull() {
            addCriterion("show_price is null");
            return (Criteria) this;
        }

        public Criteria andShow_priceIsNotNull() {
            addCriterion("show_price is not null");
            return (Criteria) this;
        }

        public Criteria andShow_priceEqualTo(String value) {
            addCriterion("show_price =", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceNotEqualTo(String value) {
            addCriterion("show_price <>", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceGreaterThan(String value) {
            addCriterion("show_price >", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceGreaterThanOrEqualTo(String value) {
            addCriterion("show_price >=", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceLessThan(String value) {
            addCriterion("show_price <", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceLessThanOrEqualTo(String value) {
            addCriterion("show_price <=", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceLike(String value) {
            addCriterion("show_price like", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceNotLike(String value) {
            addCriterion("show_price not like", value, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceIn(List<String> values) {
            addCriterion("show_price in", values, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceNotIn(List<String> values) {
            addCriterion("show_price not in", values, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceBetween(String value1, String value2) {
            addCriterion("show_price between", value1, value2, "show_price");
            return (Criteria) this;
        }

        public Criteria andShow_priceNotBetween(String value1, String value2) {
            addCriterion("show_price not between", value1, value2, "show_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceIsNull() {
            addCriterion("group_price is null");
            return (Criteria) this;
        }

        public Criteria andGroup_priceIsNotNull() {
            addCriterion("group_price is not null");
            return (Criteria) this;
        }

        public Criteria andGroup_priceEqualTo(Double value) {
            addCriterion("group_price =", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceNotEqualTo(Double value) {
            addCriterion("group_price <>", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceGreaterThan(Double value) {
            addCriterion("group_price >", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceGreaterThanOrEqualTo(Double value) {
            addCriterion("group_price >=", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceLessThan(Double value) {
            addCriterion("group_price <", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceLessThanOrEqualTo(Double value) {
            addCriterion("group_price <=", value, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceIn(List<Double> values) {
            addCriterion("group_price in", values, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceNotIn(List<Double> values) {
            addCriterion("group_price not in", values, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceBetween(Double value1, Double value2) {
            addCriterion("group_price between", value1, value2, "group_price");
            return (Criteria) this;
        }

        public Criteria andGroup_priceNotBetween(Double value1, Double value2) {
            addCriterion("group_price not between", value1, value2, "group_price");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("price is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("price is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Double value) {
            addCriterion("price =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Double value) {
            addCriterion("price <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Double value) {
            addCriterion("price >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("price >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Double value) {
            addCriterion("price <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Double value) {
            addCriterion("price <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Double> values) {
            addCriterion("price in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Double> values) {
            addCriterion("price not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Double value1, Double value2) {
            addCriterion("price between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Double value1, Double value2) {
            addCriterion("price not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andAllcityIsNull() {
            addCriterion("allcity is null");
            return (Criteria) this;
        }

        public Criteria andAllcityIsNotNull() {
            addCriterion("allcity is not null");
            return (Criteria) this;
        }

        public Criteria andAllcityEqualTo(Integer value) {
            addCriterion("allcity =", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityNotEqualTo(Integer value) {
            addCriterion("allcity <>", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityGreaterThan(Integer value) {
            addCriterion("allcity >", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityGreaterThanOrEqualTo(Integer value) {
            addCriterion("allcity >=", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityLessThan(Integer value) {
            addCriterion("allcity <", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityLessThanOrEqualTo(Integer value) {
            addCriterion("allcity <=", value, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityIn(List<Integer> values) {
            addCriterion("allcity in", values, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityNotIn(List<Integer> values) {
            addCriterion("allcity not in", values, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityBetween(Integer value1, Integer value2) {
            addCriterion("allcity between", value1, value2, "allcity");
            return (Criteria) this;
        }

        public Criteria andAllcityNotBetween(Integer value1, Integer value2) {
            addCriterion("allcity not between", value1, value2, "allcity");
            return (Criteria) this;
        }

        public Criteria andUniformpriceIsNull() {
            addCriterion("uniformprice is null");
            return (Criteria) this;
        }

        public Criteria andUniformpriceIsNotNull() {
            addCriterion("uniformprice is not null");
            return (Criteria) this;
        }

        public Criteria andUniformpriceEqualTo(Integer value) {
            addCriterion("uniformprice =", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceNotEqualTo(Integer value) {
            addCriterion("uniformprice <>", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceGreaterThan(Integer value) {
            addCriterion("uniformprice >", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("uniformprice >=", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceLessThan(Integer value) {
            addCriterion("uniformprice <", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceLessThanOrEqualTo(Integer value) {
            addCriterion("uniformprice <=", value, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceIn(List<Integer> values) {
            addCriterion("uniformprice in", values, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceNotIn(List<Integer> values) {
            addCriterion("uniformprice not in", values, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceBetween(Integer value1, Integer value2) {
            addCriterion("uniformprice between", value1, value2, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andUniformpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("uniformprice not between", value1, value2, "uniformprice");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNull() {
            addCriterion("barcode is null");
            return (Criteria) this;
        }

        public Criteria andBarcodeIsNotNull() {
            addCriterion("barcode is not null");
            return (Criteria) this;
        }

        public Criteria andBarcodeEqualTo(String value) {
            addCriterion("barcode =", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotEqualTo(String value) {
            addCriterion("barcode <>", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThan(String value) {
            addCriterion("barcode >", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeGreaterThanOrEqualTo(String value) {
            addCriterion("barcode >=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThan(String value) {
            addCriterion("barcode <", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLessThanOrEqualTo(String value) {
            addCriterion("barcode <=", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeLike(String value) {
            addCriterion("barcode like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotLike(String value) {
            addCriterion("barcode not like", value, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeIn(List<String> values) {
            addCriterion("barcode in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotIn(List<String> values) {
            addCriterion("barcode not in", values, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeBetween(String value1, String value2) {
            addCriterion("barcode between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andBarcodeNotBetween(String value1, String value2) {
            addCriterion("barcode not between", value1, value2, "barcode");
            return (Criteria) this;
        }

        public Criteria andExpirydayIsNull() {
            addCriterion("expiryday is null");
            return (Criteria) this;
        }

        public Criteria andExpirydayIsNotNull() {
            addCriterion("expiryday is not null");
            return (Criteria) this;
        }

        public Criteria andExpirydayEqualTo(Integer value) {
            addCriterion("expiryday =", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayNotEqualTo(Integer value) {
            addCriterion("expiryday <>", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayGreaterThan(Integer value) {
            addCriterion("expiryday >", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayGreaterThanOrEqualTo(Integer value) {
            addCriterion("expiryday >=", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayLessThan(Integer value) {
            addCriterion("expiryday <", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayLessThanOrEqualTo(Integer value) {
            addCriterion("expiryday <=", value, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayIn(List<Integer> values) {
            addCriterion("expiryday in", values, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayNotIn(List<Integer> values) {
            addCriterion("expiryday not in", values, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayBetween(Integer value1, Integer value2) {
            addCriterion("expiryday between", value1, value2, "expiryday");
            return (Criteria) this;
        }

        public Criteria andExpirydayNotBetween(Integer value1, Integer value2) {
            addCriterion("expiryday not between", value1, value2, "expiryday");
            return (Criteria) this;
        }

        public Criteria andRedalertIsNull() {
            addCriterion("redalert is null");
            return (Criteria) this;
        }

        public Criteria andRedalertIsNotNull() {
            addCriterion("redalert is not null");
            return (Criteria) this;
        }

        public Criteria andRedalertEqualTo(Integer value) {
            addCriterion("redalert =", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertNotEqualTo(Integer value) {
            addCriterion("redalert <>", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertGreaterThan(Integer value) {
            addCriterion("redalert >", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertGreaterThanOrEqualTo(Integer value) {
            addCriterion("redalert >=", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertLessThan(Integer value) {
            addCriterion("redalert <", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertLessThanOrEqualTo(Integer value) {
            addCriterion("redalert <=", value, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertIn(List<Integer> values) {
            addCriterion("redalert in", values, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertNotIn(List<Integer> values) {
            addCriterion("redalert not in", values, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertBetween(Integer value1, Integer value2) {
            addCriterion("redalert between", value1, value2, "redalert");
            return (Criteria) this;
        }

        public Criteria andRedalertNotBetween(Integer value1, Integer value2) {
            addCriterion("redalert not between", value1, value2, "redalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertIsNull() {
            addCriterion("yellowalert is null");
            return (Criteria) this;
        }

        public Criteria andYellowalertIsNotNull() {
            addCriterion("yellowalert is not null");
            return (Criteria) this;
        }

        public Criteria andYellowalertEqualTo(Integer value) {
            addCriterion("yellowalert =", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertNotEqualTo(Integer value) {
            addCriterion("yellowalert <>", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertGreaterThan(Integer value) {
            addCriterion("yellowalert >", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertGreaterThanOrEqualTo(Integer value) {
            addCriterion("yellowalert >=", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertLessThan(Integer value) {
            addCriterion("yellowalert <", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertLessThanOrEqualTo(Integer value) {
            addCriterion("yellowalert <=", value, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertIn(List<Integer> values) {
            addCriterion("yellowalert in", values, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertNotIn(List<Integer> values) {
            addCriterion("yellowalert not in", values, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertBetween(Integer value1, Integer value2) {
            addCriterion("yellowalert between", value1, value2, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andYellowalertNotBetween(Integer value1, Integer value2) {
            addCriterion("yellowalert not between", value1, value2, "yellowalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertIsNull() {
            addCriterion("greenalert is null");
            return (Criteria) this;
        }

        public Criteria andGreenalertIsNotNull() {
            addCriterion("greenalert is not null");
            return (Criteria) this;
        }

        public Criteria andGreenalertEqualTo(Integer value) {
            addCriterion("greenalert =", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertNotEqualTo(Integer value) {
            addCriterion("greenalert <>", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertGreaterThan(Integer value) {
            addCriterion("greenalert >", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertGreaterThanOrEqualTo(Integer value) {
            addCriterion("greenalert >=", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertLessThan(Integer value) {
            addCriterion("greenalert <", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertLessThanOrEqualTo(Integer value) {
            addCriterion("greenalert <=", value, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertIn(List<Integer> values) {
            addCriterion("greenalert in", values, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertNotIn(List<Integer> values) {
            addCriterion("greenalert not in", values, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertBetween(Integer value1, Integer value2) {
            addCriterion("greenalert between", value1, value2, "greenalert");
            return (Criteria) this;
        }

        public Criteria andGreenalertNotBetween(Integer value1, Integer value2) {
            addCriterion("greenalert not between", value1, value2, "greenalert");
            return (Criteria) this;
        }

        public Criteria andSharpidIsNull() {
            addCriterion("sharpid is null");
            return (Criteria) this;
        }

        public Criteria andSharpidIsNotNull() {
            addCriterion("sharpid is not null");
            return (Criteria) this;
        }

        public Criteria andSharpidEqualTo(Integer value) {
            addCriterion("sharpid =", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidNotEqualTo(Integer value) {
            addCriterion("sharpid <>", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidGreaterThan(Integer value) {
            addCriterion("sharpid >", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidGreaterThanOrEqualTo(Integer value) {
            addCriterion("sharpid >=", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidLessThan(Integer value) {
            addCriterion("sharpid <", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidLessThanOrEqualTo(Integer value) {
            addCriterion("sharpid <=", value, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidIn(List<Integer> values) {
            addCriterion("sharpid in", values, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidNotIn(List<Integer> values) {
            addCriterion("sharpid not in", values, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidBetween(Integer value1, Integer value2) {
            addCriterion("sharpid between", value1, value2, "sharpid");
            return (Criteria) this;
        }

        public Criteria andSharpidNotBetween(Integer value1, Integer value2) {
            addCriterion("sharpid not between", value1, value2, "sharpid");
            return (Criteria) this;
        }
    }

    /**
     * productsku
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * productsku 2018-08-20
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}